MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Alpha Sort = 1312

Search:

descending

Link	rowid ▼	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Artist Role	Artist Display Name	Artist Display Bio	Artist Alpha Sort	Artist Nationality	Artist Begin Date	Artist End Date	Object Date	Object Begin Date	Object End Date	Medium	Dimensions	Credit Line	Classification	Link Resource	Metadata Date	Repository
9588	9588	22.89	1	10354	American Paintings and Sculpture 2	Sculpture 100	Man Cub	Artist 2	Alexander Stirling Calder	American, Philadelphia, Pennsylvania 1870–1945 Brooklyn, New York	Calder, Alexander Stirling 1312	American 1	1870	1945	1901–2, cast 1922	1901	1922	Bronze 23	45 x 15 x 14 in. (114.3 x 38.1 x 35.6 cm)	Rogers Fund, 1922	Sculpture 12	http://www.metmuseum.org/art/collection/search/10354	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
9589	9589	22.154	1	10355	American Paintings and Sculpture 2	Sculpture 100	Scratching Her Heel	Artist 2	Alexander Stirling Calder	American, Philadelphia, Pennsylvania 1870–1945 Brooklyn, New York	Calder, Alexander Stirling 1312	American 1	1870	1945	1921	1921	1921	Bronze 23	12 x 5 x 5 in. (30.5 x 12.7 x 12.7 cm)	Rogers Fund, 1922	Sculpture 12	http://www.metmuseum.org/art/collection/search/10355	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
9590	9590	63.200.8	1	10356	American Paintings and Sculpture 2	Watercolor 198	Seated Nude	Artist 2	Alexander Stirling Calder	American, Philadelphia, Pennsylvania 1870–1945 Brooklyn, New York	Calder, Alexander Stirling 1312	American 1	1870	1945	ca. 1920s	1917	1920	Watercolor and red chalk on tan wove paper 1470	11 3/4 x 17 in. (29.8 x 43.2 cm)	Gift of Mrs. Darwin S. Morse, 1963	Drawings 9	http://www.metmuseum.org/art/collection/search/10356	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
13621	13621	38.111.1	1	14783	American Paintings and Sculpture 2	Medal 148	Life as a Dance	Artist 2	Alexander Stirling Calder	American, Philadelphia, Pennsylvania 1870–1945 Brooklyn, New York	Calder, Alexander Stirling 1312	American 1	1870	1945	1938	1938	1938	Bronze and gold leaf 329	Diam. 2 3/4 in. (7 cm)	Gift of the Society of Medalists, 1938	Sculpture 12	http://www.metmuseum.org/art/collection/search/14783	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
13622	13622	38.111.2	1	14784	American Paintings and Sculpture 2	Medal 148	Life as a Dance	Artist 2	Alexander Stirling Calder	American, Philadelphia, Pennsylvania 1870–1945 Brooklyn, New York	Calder, Alexander Stirling 1312	American 1	1870	1945	1938	1938	1938	Bronze and gold leaf 329	Diam. 2 3/4 in. (7 cm)	Gift of the Society of Medalists, 1938	Sculpture 12	http://www.metmuseum.org/art/collection/search/14784	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");